2013-09-11 - 8897.100 - Enhancement - Year to Date FI115 #CrystalReportDevelopment

ENHANCEMENT

8897.100 - Year to Date FI115

Requirement Summary

---

Need to Create Year to Date field in FI115.

Admin Info

---

Purpose	Year to Date FI115
Requested By	Jack Mehltretter
Spec Created By	Praveen Guntuka
Spec Created Date	09/11/2013
Spec QA by	Uday Kumar P
Objects	FI115
Document Status	Complete

References

---

Prior Tickets

None

Documents

None

Functional Requirement

---

1. We have an existing FI115 Crystal report in BI production.
2. In FI115 report we are showing Actual, Budget, Variance and Variance Percentage values for Current Period and as well as Year to Date.
3. In New report we have to include last year Actual values and need to show their respective Variance and Variance Percentage values for Current Period and as well as Year to Date.

Solution Summary

---

1. Need to import the existing FI115 report in to Crystal Report designer.
2. Need to change the existing formulas.
3. Need to place the new fields in the report.
4. Report the changes to NEC.

Test Plan

SNo.	Test Scenario	Expected Results
1.	Report Format	As per NEC standards
2.	Execute Crystal Report in Crystal Designer tool after changes	Report should execute successfully in Crystal Designer tool
3.	Scheduling the Report in NEC BI Launch Pad	Report should execute successfully in NEC BI Launch Pad
4.	Validating the new Report with BEx Query	Report values should validate against BEx query

Solution Details

---

1. Need to import the existing FI115 report from the production server.
2. Need to include the fields in the existing report.
3. Need to apply the formatting changes in the report.
4. Need to add/remove respective formulas in the report.
5. Need to add/remove logic for the respective formulas in the report.
6. Need to add the respective suppress conditions in the report.

Issues

---

None